from sqlalchemy import Column
from sqlalchemy.dialects.oracle import VARCHAR2
from app.db.base import Base

# Gateway School Entity
class GatewaySchool(Base):
    __tablename__ = 'GATEWAY_SCHOOL'
    __table_args__ = {'schema': 'IARO_CAREER'}

    school_id = Column(VARCHAR2(50), primary_key=True)
    school_name = Column(VARCHAR2(500))
    is_gateway = Column(VARCHAR2(1))  # Values: 'Y' or 'N'